﻿USE [csc640_fall2011_team3];
SET NOCOUNT ON;
SET XACT_ABORT ON;
GO

SET IDENTITY_INSERT [dbo].[QuestionCategory] ON;

BEGIN TRANSACTION;
INSERT INTO [dbo].[QuestionCategory]([CategoryID], [CategoryDescription])
SELECT 2, N'MyHealthMeasurements' UNION ALL
SELECT 3, N'MyHealthHistory' UNION ALL
SELECT 4, N'MyHealthRiskFactors'
COMMIT;
RAISERROR (N'[dbo].[QuestionCategory]: Insert Batch: 1.....Done!', 10, 1) WITH NOWAIT;
GO

SET IDENTITY_INSERT [dbo].[QuestionCategory] OFF;

SET IDENTITY_INSERT [dbo].[QuestionProcessing] ON;

BEGIN TRANSACTION;
INSERT INTO [dbo].[QuestionProcessing]([QuestionProcessingID], [QuestionID], [FieldName], [QuestionProcessingType], [QuestionProcessingValues])
SELECT 1, 3, N'tbHeightft', N'MyHealthByDesign.Domain.Processing.Range', N'1|10' UNION ALL
SELECT 2, 3, N'tbHeightin', N'MyHealthByDesign.Domain.Processing.Range', N'0|11' UNION ALL
SELECT 3, 5, N'tbWaistCircIn', N'MyHealthByDesign.Domain.Processing.InchCentimeterConversion', N'onblur|calcInchesToCentimeters(''tbWaistCircIn'', ''tbWaistCircCm'')' UNION ALL
SELECT 4, 5, N'tbWaistCircCm', N'MyHealthByDesign.Domain.Processing.InchCentimeterConversion', N'onblur|calcCentimetersToInches(''tbWaistCircIn'', ''tbWaistCircCm'')' UNION ALL
SELECT 5, 5, N'tbWaistCircIn', N'MyHealthByDesign.Domain.Processing.InchCentimeterConversion', N'onpaste|calcInchesToCentimeters(''tbWaistCircIn'', ''tbWaistCircCm'')' UNION ALL
SELECT 6, 5, N'tbWaistCircCm', N'MyHealthByDesign.Domain.Processing.InchCentimeterConversion', N'onpaste|calcCentimetersToInches(''tbWaistCircIn'', ''tbWaistCircCm'')' UNION ALL
SELECT 7, 1, N'tbWeight', N'MyHealthByDesign.Domain.Processing.BMI', N'onblur|calcBMI(''tbHeightft'', ''tbHeightin'', ''tbWeight'', ''tbBMI'')' UNION ALL
SELECT 8, 1, N'tbWeight', N'MyHealthByDesign.Domain.Processing.BMI', N'onpaste|calcBMI(''tbHeightft'', ''tbHeightin'', ''tbWeight'', ''tbBMI'')' UNION ALL
SELECT 9, 3, N'tbHeightft', N'MyHealthByDesign.Domain.Processing.BMI', N'onchange|calcBMI(''tbHeightft'', ''tbHeightin'', ''tbWeight'', ''tbBMI'')' UNION ALL
SELECT 10, 3, N'tbHeightft', N'MyHealthByDesign.Domain.Processing.BMI', N'onchange|calcBMI(''tbHeightft'', ''tbHeightin'', ''tbWeight'', ''tbBMI'')' UNION ALL
SELECT 11, 3, N'tbHeightin', N'MyHealthByDesign.Domain.Processing.BMI', N'onchange|calcBMI(''tbHeightft'', ''tbHeightin'', ''tbWeight'', ''tbBMI'')' UNION ALL
SELECT 12, 3, N'tbHeightin', N'MyHealthByDesign.Domain.Processing.BMI', N'onchange|calcBMI(''tbHeightft'', ''tbHeightin'', ''tbWeight'', ''tbBMI'')' UNION ALL
SELECT 13, 4, N'tbBMI', N'MyHealthByDesign.Domain.Processing.BMI', N'readonly|readonly'
COMMIT;
RAISERROR (N'[dbo].[QuestionProcessing]: Insert Batch: 1.....Done!', 10, 1) WITH NOWAIT;
GO

SET IDENTITY_INSERT [dbo].[QuestionProcessing] OFF;

SET IDENTITY_INSERT [dbo].[Users] ON;

BEGIN TRANSACTION;
INSERT INTO [dbo].[Users]([UserId], [Email], [Password], [Firstname], [Lastname], [BirthDate], [Gender], [Ethnicity], [StreetAddress], [City], [State], [ZipCode], [MobilePhone], [Country], [TextFlag], [CertificationDate], [DisclaimerDate], [Administrator])
SELECT 1, N'john@gmail.com', N'test', N'John', N'Doe', '19760105 00:00:00.000', N'M', N'Caucasian (non-Hispanic)', N'8713 Yosemite Ct.', N'Bothell', N'WA', N'98011', N'2627872872', N'US', N'N', '20111210 00:00:00.000', '20111209 00:00:00.000', NULL UNION ALL
SELECT 2, N'mark.servais@gmail.com', N'test', N'Aaron', N'Rodgers', '19650214 00:00:00.000', N'M', N'Native American', N'1265 Lombardi Avenue ', N'Green Bay', N'WI', N'54307', NULL, N'US', N'N', '20111119 00:00:00.000', NULL, NULL UNION ALL
SELECT 3, N'chris@gmail.com', N'test', N'Chris', N'John', '19880124 00:00:00.000', N'M', N'Asian', NULL, N'Pewaukee', NULL, N'WI', NULL, NULL, NULL, NULL, NULL, NULL UNION ALL
SELECT 4, N'sam@gmail.com', N'test', N'Sam', N'Test', '19760101 00:00:00.000', N'F', N'Hispanic Latino', NULL, N'Waukesha', NULL, N'53189', N'NULL', NULL, N'N', NULL, NULL, NULL UNION ALL
SELECT 6, N'alisha@gmail.com', N'test', N'Alisha', N'Test', '19560123 00:00:00.000', N'F', N'Native American', NULL, N'Whitewater', NULL, N'53190', N'262-762-7622', NULL, N'N', '20111209 00:00:00.000', NULL, NULL UNION ALL
SELECT 7, N'packer@gmail.com', N'test', N'Packers', N'Test', '19560102 00:00:00.000', N'M', N'Hispanic Latino', NULL, N'Waukesha', NULL, N'53190', N'NULL', NULL, N'N', NULL, NULL, NULL UNION ALL
SELECT 8, N'mgross4@wi.rr.com', N'Test1234', N'Doe', N'Jane', '19900101 00:00:00.000', N'F', N'Caucasian (non-Hispanic)', NULL, N'Franklin', NULL, N'53132', N'NULL', NULL, N'N', '20111205 00:00:00.000', NULL, NULL UNION ALL
SELECT 10, N'sanjeev40084@gmail.com', N'test', N'Sanjeev', N'Shrestha', '19800101 00:00:00.000', N'M', N'Asian', NULL, N'Pewaukee', NULL, N'53072', N'NULL', NULL, N'N', '20111204 00:00:00.000', '20111204 00:00:00.000', NULL UNION ALL
SELECT 11, N'cboyea@pio.carrollu.edu', N'Smarter', N'Bob', N'Smith', '20100902 00:00:00.000', N'M', N'Caucasian (non-Hispanic)', NULL, N'Waukesha', NULL, N'53151', N'NULL', NULL, N'N', NULL, NULL, NULL UNION ALL
SELECT 12, N'jsaccomando@gmail.com', N'test', N'Jeff', N'Saccomando', '19780830 00:00:00.000', N'M', N'Caucasian (non-Hispanic)', NULL, N'Waukesha', NULL, N'53186', N'NULL', NULL, N'N', NULL, NULL, NULL UNION ALL
SELECT 13, N'bob@gmail.com', N'test', N'Bob', N'Star', '19661112 00:00:00.000', N'M', N'Caucasian (non-Hispanic)', NULL, N'Pewaukee', NULL, N'53072', N'NULL', NULL, N'N', NULL, NULL, NULL UNION ALL
SELECT 17, N'lsenkows@pio.carrollu.edu', N'ptschool', N'Carol', N'Smith', '19760410 00:00:00.000', N'F', N'Caucasian (non-Hispanic)', NULL, N'Waukesha', NULL, N'53186', N'NULL', NULL, N'N', '20111109 00:00:00.000', '20111109 00:00:00.000', NULL UNION ALL
SELECT 18, N'skotschi@carrollu.edu', N'sunshine', N'Sara', N'Kotschi', '19880720 00:00:00.000', N'F', N'Caucasian (non-Hispanic)', NULL, N'Waukesha', NULL, N'53186', N'NULL', NULL, N'N', '20111109 00:00:00.000', NULL, NULL UNION ALL
SELECT 20, N'johnny@gmail.com', N'test', N'Test', N'Johnny', '19780101 00:00:00.000', N'M', N'Caucasian (non-Hispanic)', NULL, N'Pewaukee', NULL, N'53190', N'NULL', NULL, N'N', NULL, NULL, NULL UNION ALL
SELECT 21, N'dan@gmail.com', N'testes', N'Test', N'Test', '19800101 00:00:00.000', N'M', N'Caucasian (non-Hispanic)', NULL, N'Pewaukee', NULL, N'53890', N'NULL', NULL, N'N', NULL, NULL, NULL UNION ALL
SELECT 23, N'janet@gmail.com', N'testtest', N'Janet', N'Test', '19000101 00:00:00.000', N'M', N'Caucasian (non-Hispanic)', NULL, N'Teasea', NULL, N'53134', N'NULL', NULL, N'N', NULL, NULL, NULL UNION ALL
SELECT 24, N'maya@gmail.com', N'testtest', N'Maya', N'Test', '18980101 00:00:00.000', N'F', N'Caucasian (non-Hispanic)', NULL, N'Pewaukee', N'WI', N'53189', N'NULL', NULL, N'N', NULL, NULL, NULL UNION ALL
SELECT 26, N'henry@gmail.com', N'testtest', N'Henry', N'Test', '19550101 00:00:00.000', N'M', N'Caucasian (non-Hispanic)', NULL, N'Pewaukee', N'WI', N'53072', N'NULL', NULL, N'N', NULL, NULL, NULL UNION ALL
SELECT 27, N'sanjeev40084@yahoo.com', N'testtest', N'Sanjeev', N'Test', '19170101 00:00:00.000', N'M', N'Asian', NULL, N'Pewaukee', N'WI', N'53072', N'NULL', NULL, N'N', '20111119 00:00:00.000', NULL, NULL UNION ALL
SELECT 28, N'mark@gmail.com', N'testtest', N'Mark', N'Test', '19380302 00:00:00.000', N'M', N'Caucasian (non-Hispanic)', NULL, N'Pewaukee', N'AL', N'53489', N'NULL', NULL, N'N', NULL, NULL, NULL UNION ALL
SELECT 29, N'joe@nowhere.com', N'testing', N'Joe', N'Blow', '19670126 00:00:00.000', N'M', N'Caucasian (non-Hispanic)', NULL, N'Madison', N'WI', N'53562', N'555-555-5555', NULL, N'N', '20111119 00:00:00.000', '20111119 00:00:00.000', NULL UNION ALL
SELECT 30, N'moey1965@yahoo.com', N'Test1234', N'Moey', N'Gross', '19650722 00:00:00.000', N'F', N'Caucasian (non-Hispanic)', NULL, N'555 W. Main Street', N'WI', N'53132', N'NULL', NULL, N'N', '20111120 00:00:00.000', NULL, NULL UNION ALL
SELECT 34, N'admin@gmail.com', N'admin', N'Administrator', N'Dave', '19081221 00:00:00.000', N'F', N'Asian', NULL, N'Calcutta', N'IN', N'87564', NULL, N'US', N'N', NULL, NULL, N'Y'
COMMIT;
RAISERROR (N'[dbo].[Users]: Insert Batch: 1.....Done!', 10, 1) WITH NOWAIT;
GO

SET IDENTITY_INSERT [dbo].[Users] OFF;

SET IDENTITY_INSERT [dbo].[Question] ON;

BEGIN TRANSACTION;
INSERT INTO [dbo].[Question]([QuestionID], [QuestionCategoryID], [QuestionSortOrder], [DisplayType], [FieldName], [FieldLabel], [FieldCSS], [FieldSuffix], [FieldHelpText], [FieldHelpURL], [QuestionActive])
SELECT 1, 2, 1, N'MyHealthByDesign.Domain.Panels.SimpleTextBox', N'tbWeight', N'Weight:', N'threeLengthTextBox', N'lbs', N'', N'', 1 UNION ALL
SELECT 3, 2, 2, N'MyHealthByDesign.Domain.Panels.RangeDropDownList', N'tbHeightft|tbHeightin', N'Height:', N'twoDigitDropDown|twoDigitDropDown', N'ft|in', N'', N'', 1 UNION ALL
SELECT 4, 2, 3, N'MyHealthByDesign.Domain.Panels.SimpleTextBox', N'tbBMI', N'BMI:', N'fourLengthTextBox', N'kg/m2', N'[What does my BMI mean?]', N'Help/BMI.htm', 1 UNION ALL
SELECT 5, 2, 4, N'MyHealthByDesign.Domain.Panels.MultipleTextBoxes', N'tbWaistCircIn|tbWaistCircCm', N'Waist Circumference:', N'threeLengthTextBox|threeLengthTextBox', N'in ( | cm)', N'[How do I measure waist circumference?]', N'Help/WaistCir.htm', 1 UNION ALL
SELECT 6, 2, 5, N'MyHealthByDesign.Domain.Panels.MultipleTextBoxes', N'tbBPSystolic|tbBPDiastolic', N'Blood Pressure:', N'fourLengthTextBox|fourLengthTextBox', N'/|mmHg', N'[What if I don''t know my blood pressure?]', N'Help/BloodPressure.htm', 1 UNION ALL
SELECT 8, 2, 6, N'MyHealthByDesign.Domain.Panels.SimpleTextBox', N'tbRestingHeartRate', N'Resting Heart Rate:', N'fourLengthTextBox', N'bpm', N'[How do I measure my heart rate?]', N'Help/HeartRate.htm', 1 UNION ALL
SELECT 9, 2, 7, N'MyHealthByDesign.Domain.Panels.TextBoxWithChecklist', N'tbBloodGlucose|cbUnknownBloodGlucose', N'Blood Glucose:', N'fourLengthTextBox|', N'mg/dl|I don''t know my blood glucose levels.', NULL, NULL, 1 UNION ALL
SELECT 10, 2, 8, N'MyHealthByDesign.Domain.Panels.TextBoxWithChecklist', N'tbTotalCholestorol|cbTotalCholesterol', N'Total Cholesterol:', N'fourLengthTextBox|', N'mg/dl|I don''t know my total cholesterol levels.', NULL, NULL, 1 UNION ALL
SELECT 11, 2, 9, N'MyHealthByDesign.Domain.Panels.TextBoxWithChecklist', N'tbLDLCholesterol|cbUnknownLDLCholesterol', N'LDL Cholesterol:', N'fourLengthTextBox|', N'mg/dl|I don''t know my LDL cholesterol levels.', NULL, NULL, 1 UNION ALL
SELECT 12, 2, 10, N'MyHealthByDesign.Domain.Panels.TextBoxWithChecklist', N'tbHDLCholesterol|cbUnknownHDLCholesterol', N'HDL Cholesterol:', N'fourLengthTextBox|', N'mg/dl|I don''t know my HDL cholesterol levels.', NULL, NULL, 1 UNION ALL
SELECT 14, 2, 11, N'MyHealthByDesign.Domain.Panels.CheckBoxList', NULL, N'Physical Activity Level (select one):', N'', N'', N'[How do I determine my activity level?]', N'Help/ActivityLevel.htm', 1 UNION ALL
SELECT 15, 3, 1, N'MyHealthByDesign.Domain.Panels.RadioList', N'rdlPregnant', N'Are you pregnant or breast feeding?', N'listcheckbox', N'', N'', N'', 0 UNION ALL
SELECT 16, 3, 2, N'MyHealthByDesign.Domain.Panels.LongLabelMessageBox', N'tbCurrentMedications', N'What medications are you currently taking?', N'longLengthTextBox', N'', N'', N'', 1 UNION ALL
SELECT 17, 3, 4, N'MyHealthByDesign.Domain.Panels.LongLabelMessageBox', N'tbCurrentVitamins', N'What vitamins are you currently taking?', N'longLengthTextBox', N'', N'', N'', 1 UNION ALL
SELECT 18, 3, 3, N'MyHealthByDesign.Domain.Panels.LongLabelMessageBox', N'tbCurrentSupplements', N'What supplements are you currently taking?', N'longLengthTextBox', N'', N'', N'', 1 UNION ALL
SELECT 19, 3, 5, N'MyHealthByDesign.Domain.Panels.LongLabelMessageBox', N'tbPastSurgeries', N'What surgeries have you gone through in the past?', N'longLengthTextBox', NULL, NULL, NULL, 1 UNION ALL
SELECT 20, 3, 6, N'MyHealthByDesign.Domain.Panels.SimpleCheckBox', N'cbNotTakingMedsVitsSuppls', N'I am not taking any medications, vitamins, or supplements', NULL, NULL, NULL, NULL, 1 UNION ALL
SELECT 21, 3, 7, N'MyHealthByDesign.Domain.Panels.SimpleCheckBox', N'cbNoSurgeries', N'I have not had any surgeries', NULL, NULL, NULL, NULL, 1 UNION ALL
SELECT 22, 3, 8, N'MyHealthByDesign.Domain.Panels.CheckBoxList', NULL, N'Have you been diagnosed as having any of the following conditions? (check all that apply):', NULL, NULL, NULL, NULL, 1 UNION ALL
SELECT 23, 4, 1, N'MyHealthByDesign.Domain.Panels.CheckBoxList', NULL, N'Age:', NULL, NULL, NULL, NULL, 1 UNION ALL
SELECT 24, 4, 2, N'MyHealthByDesign.Domain.Panels.CheckBoxList', NULL, N'Diagnosed Disease', NULL, NULL, NULL, NULL, 1 UNION ALL
SELECT 25, 4, 3, N'MyHealthByDesign.Domain.Panels.CheckBoxList', NULL, N'Family History<br />Do you have a family member who has had a <a href="help/MyocardialInfarction.htm" class="helplink">mycardial infarction</a>, coronary revascularization, or sudden death?', NULL, NULL, NULL, NULL, 1 UNION ALL
SELECT 26, 4, 4, N'MyHealthByDesign.Domain.Panels.CheckBoxList', NULL, N'Hypertension<br/>Do you have <a href="help/Hypertention.htm" class="helplink">hypertension</a>?', NULL, NULL, NULL, NULL, 1
COMMIT;
RAISERROR (N'[dbo].[Question]: Insert Batch: 1.....Done!', 10, 1) WITH NOWAIT;
GO

SET IDENTITY_INSERT [dbo].[Question] OFF;

SET IDENTITY_INSERT [dbo].[QuestionOption] ON;

BEGIN TRANSACTION;
INSERT INTO [dbo].[QuestionOption]([OptionID], [QuestionID], [OptionName], [OptionSortOrder], [OptionLabel], [OptionActive], [OptionCSS], [OptionHelpURL])
SELECT 1, 14, N'cbPASedentary', 1, N'Sedentary', 1, N'listcheckbox', NULL UNION ALL
SELECT 2, 14, N'cbPAMinimallyActive', 2, N'Minimally Active', 1, N'listcheckbox', NULL UNION ALL
SELECT 3, 14, N'cbPASomewhatActive', 3, N'Somewhat Active', 1, N'listcheckbox', NULL UNION ALL
SELECT 4, 14, N'cbPAActive', 4, N'Active', 1, N'listcheckbox', NULL UNION ALL
SELECT 5, 14, N'cbPAHighlyActive', 5, N'Highly Active', 1, N'listcheckbox', NULL UNION ALL
SELECT 6, 15, N'rbPregnantYes', 1, N'Yes', 1, N'listcheckbox', NULL UNION ALL
SELECT 7, 15, N'rbPregnantNo', 2, N'No', 1, N'listcheckbox', NULL UNION ALL
SELECT 8, 15, N'rbPregnantUnknown', 3, N'I do not know', 1, N'listcheckbox', NULL UNION ALL
SELECT 9, 22, N'cbDiagnosedArthritis', 1, N'Arthritis', 1, N'listcheckbox', NULL UNION ALL
SELECT 10, 22, N'cbDiagnosedCancer', 2, N'Cancer', 1, N'listcheckbox', NULL UNION ALL
SELECT 11, 22, N'cbDiagnosedDiabetes', 3, N'Diabetes', 1, N'listcheckbox', NULL UNION ALL
SELECT 12, 22, N'cbDiagnosedDyslipidemia', 4, N'Dyslipidemia', 1, N'listcheckbox', NULL UNION ALL
SELECT 13, 22, N'cbDiagnosedHIV', 5, N'HIV', 1, N'listcheckbox', NULL UNION ALL
SELECT 14, 22, N'cbDiagnosedHypertension', 6, N'Hypertension', 1, N'listcheckbox', NULL UNION ALL
SELECT 15, 22, N'cbDiagnosedMetabolicSyndrome', 7, N'Metabolic syndrome', 1, N'listcheckbox', NULL UNION ALL
SELECT 16, 22, N'cbDiagnosedObese', 8, N'Overwieght/Obese', 1, N'listcheckbox', NULL UNION ALL
SELECT 17, 22, N'cbDiagnosedOsteoporosis', 9, N'Osteoporosis', 1, N'listcheckbox', NULL UNION ALL
SELECT 18, 22, N'cbDiagnosedPAD', 10, N'Peripheral Artery Disease', 1, N'listcheckbox', NULL UNION ALL
SELECT 19, 22, N'cbDiagnosedRenalDisease', 11, N'Renal Disease', 1, N'listcheckbox', NULL UNION ALL
SELECT 20, 22, N'cbDiagnosedOther', 12, N'Other - Please specify:', 1, N'listcheckbox', NULL UNION ALL
SELECT 21, 23, N'cbAgeMale45Up', 1, N'I am a male 45 years or older', 1, N'listcheckbox', NULL UNION ALL
SELECT 22, 23, N'cbAgeFemale55Up', 2, N'I am a female 55 years or older', 1, N'listcheckbox', NULL UNION ALL
SELECT 23, 23, N'cbAgeFemalePreMenopause', 3, N'I am a female with <a href="help/PrematureMenopause.htm" class="helplink">premature menopause</a> without estrogen replacement therapy', 1, N'listcheckbox', NULL UNION ALL
SELECT 24, 24, N'cbDiagnosedDiseaseCardio', 1, N'I have a diagnosed <a href="help/cardiovascularDisease.htm" class="helplink">cardiovascular disease</a>', 1, N'listcheckbox', NULL UNION ALL
SELECT 25, 24, N'cbDiagnosedDiseasePulmonary', 2, N'I have a diagnosed <a href="help/PulmonaryDisease.htm" class="helplink">pulmonary disease</a>', 1, N'listcheckbox', NULL UNION ALL
SELECT 26, 24, N'cbDiagnosedDiseaseMetabolic', 3, N'I have a diagnosed <a href="help/MetabolicDisease.htm" class="helplink">metabolic disease</a>', 1, N'listcheckbox', NULL UNION ALL
SELECT 27, 24, N'cbDiagnosedDiseaseUnknown', 4, N'I do not know if I have any of the above diseases', 1, N'listcheckbox', NULL UNION ALL
SELECT 28, 24, N'cbDiagnosedDiseaseNone', 5, N'I have NONE of the above diseases', 1, N'listcheckbox', NULL UNION ALL
SELECT 29, 25, N'cbSuddenDeathMale', 1, N'My father or other male first-degree relative (brother, son) has died before the age of 55 years old from one of the above causes', 1, N'listcheckbox', NULL UNION ALL
SELECT 30, 25, N'cbSuddenDeathFemale', 2, N'My mother or other female first-degree relative (sister, daughter) has died before the age of 65 years old from one of the above causes', 1, N'listcheckbox', NULL UNION ALL
SELECT 31, 25, N'cbSuddenDeathUnknown', 3, N'I do not know this information', 1, N'listcheckbox', NULL UNION ALL
SELECT 32, 25, N'cbSuddenDeathNone', 4, N'No one in my family has died from any of these causes', 1, N'listcheckbox', NULL UNION ALL
SELECT 33, 26, N'cbHypertensionSystolic', 1, N'<a href="help/BloodPressure.htm" class="helplink">Systolic Blood Pressure</a>: 140mmHg or greater on at least 2 separate occasions', 1, N'listcheckbox', NULL UNION ALL
SELECT 34, 26, N'cbHypertensionDiastolic', 2, N'<a href="help/BloodPressure.htm" class="helplink">Diastolic Blood Pressure</a>: 90 mmHg or greater on at least 2 separate occasions', 1, N'listcheckbox', NULL UNION ALL
SELECT 35, 26, N'cbHypertensionMedication', 3, N'I am using an <a href="help/AntihyperMeds.htm" class="helplink">antihypertensive medication</a>', 1, N'listcheckbox', NULL UNION ALL
SELECT 36, 26, N'cbHypertensionUnknown', 4, N'I do not know this information', 1, N'listcheckbox', NULL UNION ALL
SELECT 37, 26, N'cbHypertensionNormal', 5, N'My blood pressure is within normal limits', 1, N'listcheckbox', NULL UNION ALL
SELECT 38, 23, N'cbAgeNoneAbove', 4, N'None of the above apply to me', 1, N'listcheckbox', NULL
COMMIT;
RAISERROR (N'[dbo].[QuestionOption]: Insert Batch: 1.....Done!', 10, 1) WITH NOWAIT;
GO

SET IDENTITY_INSERT [dbo].[QuestionOption] OFF;

SET IDENTITY_INSERT [dbo].[QuestionOptionSpecial] ON;

BEGIN TRANSACTION;
INSERT INTO [dbo].[QuestionOptionSpecial]([SpecialID], [OptionID], [SpecialName], [SpecialDisplayType])
SELECT 1, 20, N'tbDiagnosedOther', N'System.Web.UI.WebControls.TextBox'
COMMIT;
RAISERROR (N'[dbo].[QuestionOptionSpecial]: Insert Batch: 1.....Done!', 10, 1) WITH NOWAIT;
GO

SET IDENTITY_INSERT [dbo].[QuestionOptionSpecial] OFF;

SET IDENTITY_INSERT [dbo].[QuestionAnswer] ON;

BEGIN TRANSACTION;
INSERT INTO [dbo].[QuestionAnswer]([AnswerID], [QuestionID], [UserID], [FieldName], [FieldValue])
SELECT 1, 1, 1, N'tbWeight', N'250' UNION ALL
SELECT 2, 3, 1, N'tbHeightft', N'5' UNION ALL
SELECT 3, 3, 1, N'tbHeightin', N'9' UNION ALL
SELECT 4, 4, 1, N'tbBMI', N'28.9' UNION ALL
SELECT 5, 5, 1, N'tbWaistCircIn', N'32' UNION ALL
SELECT 6, 5, 1, N'tbWaistCircCm', N'81.3' UNION ALL
SELECT 7, 6, 1, N'tbBPSystolic', N'140' UNION ALL
SELECT 8, 6, 1, N'tbBPDiastolic', N'80' UNION ALL
SELECT 9, 8, 1, N'tbRestingHeartRate', N'65' UNION ALL
SELECT 10, 9, 1, N'tbBloodGlucose', N'27' UNION ALL
SELECT 11, 9, 1, N'cbUnknownBloodGlucose', N'False' UNION ALL
SELECT 12, 10, 1, N'tbTotalCholestorol', N'130' UNION ALL
SELECT 13, 10, 1, N'cbTotalCholesterol', N'True' UNION ALL
SELECT 14, 11, 1, N'tbLDLCholesterol', N'' UNION ALL
SELECT 15, 11, 1, N'cbUnknownLDLCholesterol', N'True' UNION ALL
SELECT 16, 12, 1, N'tbHDLCholesterol', N'25' UNION ALL
SELECT 17, 12, 1, N'cbUnknownHDLCholesterol', N'False' UNION ALL
SELECT 18, 14, 1, N'cbPASedentary', N'True' UNION ALL
SELECT 19, 14, 1, N'cbPAMinimallyActive', N'True' UNION ALL
SELECT 20, 14, 1, N'cbPASomewhatActive', N'False' UNION ALL
SELECT 21, 14, 1, N'cbPAActive', N'False' UNION ALL
SELECT 22, 14, 1, N'cbPAHighlyActive', N'False' UNION ALL
SELECT 23, 15, 1, N'rbPregnantYes', N'False' UNION ALL
SELECT 24, 15, 1, N'rbPregnantNo', N'False' UNION ALL
SELECT 25, 15, 1, N'rbPregnantUnknown', N'True' UNION ALL
SELECT 26, 16, 1, N'tbCurrentMedications', N'Ty' UNION ALL
SELECT 27, 17, 1, N'tbCurrentVitamins', N'Vitamin C' UNION ALL
SELECT 28, 18, 1, N'tbCurrentSupplements', N'Vitamin Supplement' UNION ALL
SELECT 29, 19, 1, N'tbPastSurgeries', N'Tonsils' UNION ALL
SELECT 30, 20, 1, N'cbNotTakingMedsVitsSuppls', N'True' UNION ALL
SELECT 31, 21, 1, N'cbNoSurgeries', N'True' UNION ALL
SELECT 32, 22, 1, N'cbDiagnosedArthritis', N'False' UNION ALL
SELECT 33, 22, 1, N'cbDiagnosedCancer', N'False' UNION ALL
SELECT 34, 22, 1, N'cbDiagnosedDiabetes', N'True' UNION ALL
SELECT 35, 22, 1, N'cbDiagnosedDyslipidemia', N'False' UNION ALL
SELECT 36, 22, 1, N'cbDiagnosedHIV', N'False' UNION ALL
SELECT 37, 22, 1, N'cbDiagnosedHypertension', N'True' UNION ALL
SELECT 38, 22, 1, N'cbDiagnosedMetabolicSyndrome', N'False' UNION ALL
SELECT 39, 22, 1, N'cbDiagnosedObese', N'True' UNION ALL
SELECT 40, 22, 1, N'cbDiagnosedOsteoporosis', N'True' UNION ALL
SELECT 41, 22, 1, N'cbDiagnosedPAD', N'False' UNION ALL
SELECT 42, 22, 1, N'cbDiagnosedRenalDisease', N'False' UNION ALL
SELECT 43, 22, 1, N'cbDiagnosedOther', N'True' UNION ALL
SELECT 44, 23, 1, N'cbAgeMale45Up', N'False' UNION ALL
SELECT 45, 23, 1, N'cbAgeFemale55Up', N'False' UNION ALL
SELECT 46, 23, 1, N'cbAgeFemalePreMenopause', N'False' UNION ALL
SELECT 47, 24, 1, N'cbDiagnosedDiseaseCardio', N'False' UNION ALL
SELECT 48, 24, 1, N'cbDiagnosedDiseasePulmonary', N'False' UNION ALL
SELECT 49, 24, 1, N'cbDiagnosedDiseaseMetabolic', N'False' UNION ALL
SELECT 50, 24, 1, N'cbDiagnosedDiseaseUnknown', N'True'
COMMIT;
RAISERROR (N'[dbo].[QuestionAnswer]: Insert Batch: 1.....Done!', 10, 1) WITH NOWAIT;
GO

BEGIN TRANSACTION;
INSERT INTO [dbo].[QuestionAnswer]([AnswerID], [QuestionID], [UserID], [FieldName], [FieldValue])
SELECT 51, 24, 1, N'cbDiagnosedDiseaseNone', N'False' UNION ALL
SELECT 52, 25, 1, N'cbSuddenDeathMale', N'True' UNION ALL
SELECT 53, 25, 1, N'cbSuddenDeathFemale', N'False' UNION ALL
SELECT 54, 25, 1, N'cbSuddenDeathUnknown', N'False' UNION ALL
SELECT 55, 25, 1, N'cbSuddenDeathNone', N'False' UNION ALL
SELECT 56, 26, 1, N'cbHypertensionSystolic', N'False' UNION ALL
SELECT 57, 26, 1, N'cbHypertensionDiastolic', N'False' UNION ALL
SELECT 58, 26, 1, N'cbHypertensionMedication', N'True' UNION ALL
SELECT 59, 26, 1, N'cbHypertensionUnknown', N'False' UNION ALL
SELECT 60, 26, 1, N'cbHypertensionNormal', N'False' UNION ALL
SELECT 61, 22, 1, N'tbDiagnosedOther', N'Chicken Lips' UNION ALL
SELECT 62, 1, 2, N'tbWeight', N'243' UNION ALL
SELECT 63, 3, 2, N'tbHeightft', N'5' UNION ALL
SELECT 64, 3, 2, N'tbHeightin', N'5' UNION ALL
SELECT 65, 4, 2, N'tbBMI', N'20' UNION ALL
SELECT 66, 5, 2, N'tbWaistCircIn', N'38' UNION ALL
SELECT 67, 5, 2, N'tbWaistCircCm', N'' UNION ALL
SELECT 68, 6, 2, N'tbBPSystolic', N'130' UNION ALL
SELECT 69, 6, 2, N'tbBPDiastolic', N'90' UNION ALL
SELECT 70, 8, 2, N'tbRestingHeartRate', N'23' UNION ALL
SELECT 71, 9, 2, N'tbBloodGlucose', N'23' UNION ALL
SELECT 72, 9, 2, N'cbUnknownBloodGlucose', N'False' UNION ALL
SELECT 73, 10, 2, N'tbTotalCholestorol', N'200' UNION ALL
SELECT 74, 10, 2, N'cbTotalCholesterol', N'False' UNION ALL
SELECT 75, 11, 2, N'tbLDLCholesterol', N'176' UNION ALL
SELECT 76, 11, 2, N'cbUnknownLDLCholesterol', N'False' UNION ALL
SELECT 77, 12, 2, N'tbHDLCholesterol', N'34' UNION ALL
SELECT 78, 12, 2, N'cbUnknownHDLCholesterol', N'False' UNION ALL
SELECT 79, 14, 2, N'cbPASedentary', N'False' UNION ALL
SELECT 80, 14, 2, N'cbPAMinimallyActive', N'False' UNION ALL
SELECT 81, 14, 2, N'cbPASomewhatActive', N'True' UNION ALL
SELECT 82, 14, 2, N'cbPAActive', N'False' UNION ALL
SELECT 83, 14, 2, N'cbPAHighlyActive', N'False' UNION ALL
SELECT 84, 15, 2, N'rbPregnantYes', N'True' UNION ALL
SELECT 85, 15, 2, N'rbPregnantNo', N'False' UNION ALL
SELECT 86, 15, 2, N'rbPregnantUnknown', N'False' UNION ALL
SELECT 87, 16, 2, N'tbCurrentMedications', N'Aleve' UNION ALL
SELECT 88, 17, 2, N'tbCurrentVitamins', N'' UNION ALL
SELECT 89, 18, 2, N'tbCurrentSupplements', N'' UNION ALL
SELECT 90, 19, 2, N'tbPastSurgeries', N'' UNION ALL
SELECT 91, 20, 2, N'cbNotTakingMedsVitsSuppls', N'False' UNION ALL
SELECT 92, 21, 2, N'cbNoSurgeries', N'True' UNION ALL
SELECT 93, 22, 2, N'cbDiagnosedArthritis', N'False' UNION ALL
SELECT 94, 22, 2, N'cbDiagnosedCancer', N'False' UNION ALL
SELECT 95, 22, 2, N'cbDiagnosedDiabetes', N'False' UNION ALL
SELECT 96, 22, 2, N'cbDiagnosedDyslipidemia', N'False' UNION ALL
SELECT 97, 22, 2, N'cbDiagnosedHIV', N'False' UNION ALL
SELECT 98, 22, 2, N'cbDiagnosedHypertension', N'False' UNION ALL
SELECT 99, 22, 2, N'cbDiagnosedMetabolicSyndrome', N'False' UNION ALL
SELECT 100, 22, 2, N'cbDiagnosedObese', N'False'
COMMIT;
RAISERROR (N'[dbo].[QuestionAnswer]: Insert Batch: 2.....Done!', 10, 1) WITH NOWAIT;
GO

BEGIN TRANSACTION;
INSERT INTO [dbo].[QuestionAnswer]([AnswerID], [QuestionID], [UserID], [FieldName], [FieldValue])
SELECT 101, 22, 2, N'cbDiagnosedOsteoporosis', N'False' UNION ALL
SELECT 102, 22, 2, N'cbDiagnosedPAD', N'False' UNION ALL
SELECT 103, 22, 2, N'cbDiagnosedRenalDisease', N'False' UNION ALL
SELECT 104, 22, 2, N'cbDiagnosedOther', N'True' UNION ALL
SELECT 105, 22, 2, N'tbDiagnosedOther', N'Fungus' UNION ALL
SELECT 106, 23, 2, N'cbAgeMale45Up', N'True' UNION ALL
SELECT 107, 23, 2, N'cbAgeFemale55Up', N'False' UNION ALL
SELECT 108, 23, 2, N'cbAgeFemalePreMenopause', N'False' UNION ALL
SELECT 109, 24, 2, N'cbDiagnosedDiseaseCardio', N'False' UNION ALL
SELECT 110, 24, 2, N'cbDiagnosedDiseasePulmonary', N'False' UNION ALL
SELECT 111, 24, 2, N'cbDiagnosedDiseaseMetabolic', N'False' UNION ALL
SELECT 112, 24, 2, N'cbDiagnosedDiseaseUnknown', N'False' UNION ALL
SELECT 113, 24, 2, N'cbDiagnosedDiseaseNone', N'True' UNION ALL
SELECT 114, 25, 2, N'cbSuddenDeathMale', N'False' UNION ALL
SELECT 115, 25, 2, N'cbSuddenDeathFemale', N'False' UNION ALL
SELECT 116, 25, 2, N'cbSuddenDeathUnknown', N'False' UNION ALL
SELECT 117, 25, 2, N'cbSuddenDeathNone', N'True' UNION ALL
SELECT 118, 26, 2, N'cbHypertensionSystolic', N'False' UNION ALL
SELECT 119, 26, 2, N'cbHypertensionDiastolic', N'False' UNION ALL
SELECT 120, 26, 2, N'cbHypertensionMedication', N'False' UNION ALL
SELECT 121, 26, 2, N'cbHypertensionUnknown', N'False' UNION ALL
SELECT 122, 26, 2, N'cbHypertensionNormal', N'True' UNION ALL
SELECT 123, 23, 8, N'cbAgeMale45Up', N'True' UNION ALL
SELECT 124, 23, 8, N'cbAgeFemale55Up', N'False' UNION ALL
SELECT 125, 23, 8, N'cbAgeFemalePreMenopause', N'False' UNION ALL
SELECT 126, 24, 8, N'cbDiagnosedDiseaseCardio', N'False' UNION ALL
SELECT 127, 24, 8, N'cbDiagnosedDiseasePulmonary', N'False' UNION ALL
SELECT 128, 24, 8, N'cbDiagnosedDiseaseMetabolic', N'False' UNION ALL
SELECT 129, 24, 8, N'cbDiagnosedDiseaseUnknown', N'False' UNION ALL
SELECT 130, 24, 8, N'cbDiagnosedDiseaseNone', N'True' UNION ALL
SELECT 131, 25, 8, N'cbSuddenDeathMale', N'False' UNION ALL
SELECT 132, 25, 8, N'cbSuddenDeathFemale', N'False' UNION ALL
SELECT 133, 25, 8, N'cbSuddenDeathUnknown', N'False' UNION ALL
SELECT 134, 25, 8, N'cbSuddenDeathNone', N'True' UNION ALL
SELECT 135, 26, 8, N'cbHypertensionSystolic', N'False' UNION ALL
SELECT 136, 26, 8, N'cbHypertensionDiastolic', N'False' UNION ALL
SELECT 137, 26, 8, N'cbHypertensionMedication', N'False' UNION ALL
SELECT 138, 26, 8, N'cbHypertensionUnknown', N'False' UNION ALL
SELECT 139, 26, 8, N'cbHypertensionNormal', N'True' UNION ALL
SELECT 206, 1, 8, N'tbWeight', N'140' UNION ALL
SELECT 207, 3, 8, N'tbHeightft', N'5' UNION ALL
SELECT 208, 3, 8, N'tbHeightin', N'7' UNION ALL
SELECT 209, 4, 8, N'tbBMI', N'' UNION ALL
SELECT 210, 5, 8, N'tbWaistCircIn', N'0' UNION ALL
SELECT 211, 5, 8, N'tbWaistCircCm', N'' UNION ALL
SELECT 212, 6, 8, N'tbBPSystolic', N'106' UNION ALL
SELECT 213, 6, 8, N'tbBPDiastolic', N'69' UNION ALL
SELECT 214, 8, 8, N'tbRestingHeartRate', N'80' UNION ALL
SELECT 215, 9, 8, N'tbBloodGlucose', N'105' UNION ALL
SELECT 216, 9, 8, N'cbUnknownBloodGlucose', N'False'
COMMIT;
RAISERROR (N'[dbo].[QuestionAnswer]: Insert Batch: 3.....Done!', 10, 1) WITH NOWAIT;
GO

BEGIN TRANSACTION;
INSERT INTO [dbo].[QuestionAnswer]([AnswerID], [QuestionID], [UserID], [FieldName], [FieldValue])
SELECT 217, 10, 8, N'tbTotalCholestorol', N'143' UNION ALL
SELECT 218, 10, 8, N'cbTotalCholesterol', N'False' UNION ALL
SELECT 219, 11, 8, N'tbLDLCholesterol', N'98' UNION ALL
SELECT 220, 11, 8, N'cbUnknownLDLCholesterol', N'False' UNION ALL
SELECT 221, 12, 8, N'tbHDLCholesterol', N'45' UNION ALL
SELECT 222, 12, 8, N'cbUnknownHDLCholesterol', N'False' UNION ALL
SELECT 223, 14, 8, N'cbPASedentary', N'False' UNION ALL
SELECT 224, 14, 8, N'cbPAMinimallyActive', N'False' UNION ALL
SELECT 225, 14, 8, N'cbPASomewhatActive', N'False' UNION ALL
SELECT 226, 14, 8, N'cbPAActive', N'False' UNION ALL
SELECT 227, 14, 8, N'cbPAHighlyActive', N'True' UNION ALL
SELECT 228, 15, 8, N'rbPregnantYes', N'False' UNION ALL
SELECT 229, 15, 8, N'rbPregnantNo', N'True' UNION ALL
SELECT 230, 15, 8, N'rbPregnantUnknown', N'False' UNION ALL
SELECT 231, 16, 8, N'tbCurrentMedications', N'Immetrex' UNION ALL
SELECT 232, 17, 8, N'tbCurrentVitamins', N'Mulit Vitamins, Vitamin C' UNION ALL
SELECT 233, 18, 8, N'tbCurrentSupplements', N'None' UNION ALL
SELECT 234, 19, 8, N'tbPastSurgeries', N'None' UNION ALL
SELECT 235, 20, 8, N'cbNotTakingMedsVitsSuppls', N'False' UNION ALL
SELECT 236, 21, 8, N'cbNoSurgeries', N'True' UNION ALL
SELECT 237, 22, 8, N'cbDiagnosedArthritis', N'False' UNION ALL
SELECT 238, 22, 8, N'cbDiagnosedCancer', N'False' UNION ALL
SELECT 239, 22, 8, N'cbDiagnosedDiabetes', N'False' UNION ALL
SELECT 240, 22, 8, N'cbDiagnosedDyslipidemia', N'False' UNION ALL
SELECT 241, 22, 8, N'cbDiagnosedHIV', N'False' UNION ALL
SELECT 242, 22, 8, N'cbDiagnosedHypertension', N'False' UNION ALL
SELECT 243, 22, 8, N'cbDiagnosedMetabolicSyndrome', N'False' UNION ALL
SELECT 244, 22, 8, N'cbDiagnosedObese', N'False' UNION ALL
SELECT 245, 22, 8, N'cbDiagnosedOsteoporosis', N'False' UNION ALL
SELECT 246, 22, 8, N'cbDiagnosedPAD', N'False' UNION ALL
SELECT 247, 22, 8, N'cbDiagnosedRenalDisease', N'False' UNION ALL
SELECT 248, 22, 8, N'cbDiagnosedOther', N'False' UNION ALL
SELECT 249, 1, 4, N'tbWeight', N'120' UNION ALL
SELECT 250, 3, 4, N'tbHeightft', N'' UNION ALL
SELECT 251, 3, 4, N'tbHeightin', N'' UNION ALL
SELECT 252, 4, 4, N'tbBMI', N'' UNION ALL
SELECT 253, 5, 4, N'tbWaistCircIn', N'' UNION ALL
SELECT 254, 5, 4, N'tbWaistCircCm', N'' UNION ALL
SELECT 255, 6, 4, N'tbBPSystolic', N'' UNION ALL
SELECT 256, 6, 4, N'tbBPDiastolic', N'' UNION ALL
SELECT 257, 8, 4, N'tbRestingHeartRate', N'' UNION ALL
SELECT 258, 9, 4, N'tbBloodGlucose', N'' UNION ALL
SELECT 259, 9, 4, N'cbUnknownBloodGlucose', N'False' UNION ALL
SELECT 260, 10, 4, N'tbTotalCholestorol', N'' UNION ALL
SELECT 261, 10, 4, N'cbTotalCholesterol', N'False' UNION ALL
SELECT 262, 11, 4, N'tbLDLCholesterol', N'' UNION ALL
SELECT 263, 11, 4, N'cbUnknownLDLCholesterol', N'False' UNION ALL
SELECT 264, 12, 4, N'tbHDLCholesterol', N'' UNION ALL
SELECT 265, 12, 4, N'cbUnknownHDLCholesterol', N'False' UNION ALL
SELECT 266, 14, 4, N'cbPASedentary', N'False'
COMMIT;
RAISERROR (N'[dbo].[QuestionAnswer]: Insert Batch: 4.....Done!', 10, 1) WITH NOWAIT;
GO

BEGIN TRANSACTION;
INSERT INTO [dbo].[QuestionAnswer]([AnswerID], [QuestionID], [UserID], [FieldName], [FieldValue])
SELECT 267, 14, 4, N'cbPAMinimallyActive', N'False' UNION ALL
SELECT 268, 14, 4, N'cbPASomewhatActive', N'False' UNION ALL
SELECT 269, 14, 4, N'cbPAActive', N'False' UNION ALL
SELECT 270, 14, 4, N'cbPAHighlyActive', N'False' UNION ALL
SELECT 271, 15, 4, N'rbPregnantYes', N'False' UNION ALL
SELECT 272, 15, 4, N'rbPregnantNo', N'False' UNION ALL
SELECT 273, 15, 4, N'rbPregnantUnknown', N'False' UNION ALL
SELECT 274, 16, 4, N'tbCurrentMedications', N'' UNION ALL
SELECT 275, 17, 4, N'tbCurrentVitamins', N'' UNION ALL
SELECT 276, 18, 4, N'tbCurrentSupplements', N'' UNION ALL
SELECT 277, 19, 4, N'tbPastSurgeries', N'' UNION ALL
SELECT 278, 20, 4, N'cbNotTakingMedsVitsSuppls', N'False' UNION ALL
SELECT 279, 21, 4, N'cbNoSurgeries', N'False' UNION ALL
SELECT 280, 22, 4, N'cbDiagnosedArthritis', N'False' UNION ALL
SELECT 281, 22, 4, N'cbDiagnosedCancer', N'False' UNION ALL
SELECT 282, 22, 4, N'cbDiagnosedDiabetes', N'False' UNION ALL
SELECT 283, 22, 4, N'cbDiagnosedDyslipidemia', N'False' UNION ALL
SELECT 284, 22, 4, N'cbDiagnosedHIV', N'False' UNION ALL
SELECT 285, 22, 4, N'cbDiagnosedHypertension', N'False' UNION ALL
SELECT 286, 22, 4, N'cbDiagnosedMetabolicSyndrome', N'False' UNION ALL
SELECT 287, 22, 4, N'cbDiagnosedObese', N'False' UNION ALL
SELECT 288, 22, 4, N'cbDiagnosedOsteoporosis', N'False' UNION ALL
SELECT 289, 22, 4, N'cbDiagnosedPAD', N'False' UNION ALL
SELECT 290, 22, 4, N'cbDiagnosedRenalDisease', N'False' UNION ALL
SELECT 291, 22, 4, N'cbDiagnosedOther', N'False' UNION ALL
SELECT 292, 23, 4, N'cbAgeMale45Up', N'False' UNION ALL
SELECT 293, 23, 4, N'cbAgeFemale55Up', N'False' UNION ALL
SELECT 294, 23, 4, N'cbAgeFemalePreMenopause', N'False' UNION ALL
SELECT 295, 24, 4, N'cbDiagnosedDiseaseCardio', N'False' UNION ALL
SELECT 296, 24, 4, N'cbDiagnosedDiseasePulmonary', N'False' UNION ALL
SELECT 297, 24, 4, N'cbDiagnosedDiseaseMetabolic', N'False' UNION ALL
SELECT 298, 24, 4, N'cbDiagnosedDiseaseUnknown', N'False' UNION ALL
SELECT 299, 24, 4, N'cbDiagnosedDiseaseNone', N'False' UNION ALL
SELECT 300, 25, 4, N'cbSuddenDeathMale', N'False' UNION ALL
SELECT 301, 25, 4, N'cbSuddenDeathFemale', N'False' UNION ALL
SELECT 302, 25, 4, N'cbSuddenDeathUnknown', N'False' UNION ALL
SELECT 303, 25, 4, N'cbSuddenDeathNone', N'False' UNION ALL
SELECT 304, 26, 4, N'cbHypertensionSystolic', N'False' UNION ALL
SELECT 305, 26, 4, N'cbHypertensionDiastolic', N'False' UNION ALL
SELECT 306, 26, 4, N'cbHypertensionMedication', N'False' UNION ALL
SELECT 307, 26, 4, N'cbHypertensionUnknown', N'False' UNION ALL
SELECT 308, 26, 4, N'cbHypertensionNormal', N'False' UNION ALL
SELECT 312, 1, 10, N'tbWeight', N'130' UNION ALL
SELECT 313, 3, 10, N'tbHeightft', N'5' UNION ALL
SELECT 314, 3, 10, N'tbHeightin', N'6' UNION ALL
SELECT 315, 4, 10, N'tbBMI', N'27' UNION ALL
SELECT 316, 5, 10, N'tbWaistCircIn', N'38' UNION ALL
SELECT 317, 5, 10, N'tbWaistCircCm', N'' UNION ALL
SELECT 318, 6, 10, N'tbBPSystolic', N'130' UNION ALL
SELECT 319, 6, 10, N'tbBPDiastolic', N'80'
COMMIT;
RAISERROR (N'[dbo].[QuestionAnswer]: Insert Batch: 5.....Done!', 10, 1) WITH NOWAIT;
GO

BEGIN TRANSACTION;
INSERT INTO [dbo].[QuestionAnswer]([AnswerID], [QuestionID], [UserID], [FieldName], [FieldValue])
SELECT 320, 8, 10, N'tbRestingHeartRate', N'65' UNION ALL
SELECT 321, 9, 10, N'tbBloodGlucose', N'20' UNION ALL
SELECT 322, 9, 10, N'cbUnknownBloodGlucose', N'False' UNION ALL
SELECT 323, 10, 10, N'tbTotalCholestorol', N'145' UNION ALL
SELECT 324, 10, 10, N'cbTotalCholesterol', N'False' UNION ALL
SELECT 325, 11, 10, N'tbLDLCholesterol', N'132' UNION ALL
SELECT 326, 11, 10, N'cbUnknownLDLCholesterol', N'False' UNION ALL
SELECT 327, 12, 10, N'tbHDLCholesterol', N'24' UNION ALL
SELECT 328, 12, 10, N'cbUnknownHDLCholesterol', N'False' UNION ALL
SELECT 329, 14, 10, N'cbPASedentary', N'True' UNION ALL
SELECT 330, 14, 10, N'cbPAMinimallyActive', N'False' UNION ALL
SELECT 331, 14, 10, N'cbPASomewhatActive', N'False' UNION ALL
SELECT 332, 14, 10, N'cbPAActive', N'False' UNION ALL
SELECT 333, 14, 10, N'cbPAHighlyActive', N'False' UNION ALL
SELECT 334, 15, 10, N'rbPregnantYes', N'False' UNION ALL
SELECT 335, 15, 10, N'rbPregnantNo', N'False' UNION ALL
SELECT 336, 15, 10, N'rbPregnantUnknown', N'False' UNION ALL
SELECT 337, 16, 10, N'tbCurrentMedications', N'' UNION ALL
SELECT 338, 17, 10, N'tbCurrentVitamins', N'' UNION ALL
SELECT 339, 18, 10, N'tbCurrentSupplements', N'' UNION ALL
SELECT 340, 19, 10, N'tbPastSurgeries', N'' UNION ALL
SELECT 341, 20, 10, N'cbNotTakingMedsVitsSuppls', N'False' UNION ALL
SELECT 342, 21, 10, N'cbNoSurgeries', N'False' UNION ALL
SELECT 343, 22, 10, N'cbDiagnosedArthritis', N'False' UNION ALL
SELECT 344, 22, 10, N'cbDiagnosedCancer', N'False' UNION ALL
SELECT 345, 22, 10, N'cbDiagnosedDiabetes', N'False' UNION ALL
SELECT 346, 22, 10, N'cbDiagnosedDyslipidemia', N'False' UNION ALL
SELECT 347, 22, 10, N'cbDiagnosedHIV', N'False' UNION ALL
SELECT 348, 22, 10, N'cbDiagnosedHypertension', N'False' UNION ALL
SELECT 349, 22, 10, N'cbDiagnosedMetabolicSyndrome', N'False' UNION ALL
SELECT 350, 22, 10, N'cbDiagnosedObese', N'False' UNION ALL
SELECT 351, 22, 10, N'cbDiagnosedOsteoporosis', N'False' UNION ALL
SELECT 352, 22, 10, N'cbDiagnosedPAD', N'False' UNION ALL
SELECT 353, 22, 10, N'cbDiagnosedRenalDisease', N'False' UNION ALL
SELECT 354, 22, 10, N'cbDiagnosedOther', N'False' UNION ALL
SELECT 355, 23, 10, N'cbAgeMale45Up', N'False' UNION ALL
SELECT 356, 23, 10, N'cbAgeFemale55Up', N'False' UNION ALL
SELECT 357, 23, 10, N'cbAgeFemalePreMenopause', N'False' UNION ALL
SELECT 358, 24, 10, N'cbDiagnosedDiseaseCardio', N'False' UNION ALL
SELECT 359, 24, 10, N'cbDiagnosedDiseasePulmonary', N'False' UNION ALL
SELECT 360, 24, 10, N'cbDiagnosedDiseaseMetabolic', N'False' UNION ALL
SELECT 361, 24, 10, N'cbDiagnosedDiseaseUnknown', N'False' UNION ALL
SELECT 362, 24, 10, N'cbDiagnosedDiseaseNone', N'False' UNION ALL
SELECT 363, 25, 10, N'cbSuddenDeathMale', N'False' UNION ALL
SELECT 364, 25, 10, N'cbSuddenDeathFemale', N'False' UNION ALL
SELECT 365, 25, 10, N'cbSuddenDeathUnknown', N'False' UNION ALL
SELECT 366, 25, 10, N'cbSuddenDeathNone', N'False' UNION ALL
SELECT 367, 26, 10, N'cbHypertensionSystolic', N'False' UNION ALL
SELECT 368, 26, 10, N'cbHypertensionDiastolic', N'False' UNION ALL
SELECT 369, 26, 10, N'cbHypertensionMedication', N'False'
COMMIT;
RAISERROR (N'[dbo].[QuestionAnswer]: Insert Batch: 6.....Done!', 10, 1) WITH NOWAIT;
GO

BEGIN TRANSACTION;
INSERT INTO [dbo].[QuestionAnswer]([AnswerID], [QuestionID], [UserID], [FieldName], [FieldValue])
SELECT 370, 26, 10, N'cbHypertensionUnknown', N'False' UNION ALL
SELECT 371, 26, 10, N'cbHypertensionNormal', N'False' UNION ALL
SELECT 483, 1, 17, N'tbWeight', N'154' UNION ALL
SELECT 484, 3, 17, N'tbHeightft', N'5' UNION ALL
SELECT 485, 3, 17, N'tbHeightin', N'8' UNION ALL
SELECT 486, 4, 17, N'tbBMI', N'' UNION ALL
SELECT 487, 5, 17, N'tbWaistCircIn', N'' UNION ALL
SELECT 488, 5, 17, N'tbWaistCircCm', N'' UNION ALL
SELECT 489, 6, 17, N'tbBPSystolic', N'' UNION ALL
SELECT 490, 6, 17, N'tbBPDiastolic', N'' UNION ALL
SELECT 491, 8, 17, N'tbRestingHeartRate', N'' UNION ALL
SELECT 492, 9, 17, N'tbBloodGlucose', N'' UNION ALL
SELECT 493, 9, 17, N'cbUnknownBloodGlucose', N'False' UNION ALL
SELECT 494, 10, 17, N'tbTotalCholestorol', N'' UNION ALL
SELECT 495, 10, 17, N'cbTotalCholesterol', N'False' UNION ALL
SELECT 496, 11, 17, N'tbLDLCholesterol', N'' UNION ALL
SELECT 497, 11, 17, N'cbUnknownLDLCholesterol', N'False' UNION ALL
SELECT 498, 12, 17, N'tbHDLCholesterol', N'' UNION ALL
SELECT 499, 12, 17, N'cbUnknownHDLCholesterol', N'False' UNION ALL
SELECT 500, 14, 17, N'cbPASedentary', N'False' UNION ALL
SELECT 501, 14, 17, N'cbPAMinimallyActive', N'True' UNION ALL
SELECT 502, 14, 17, N'cbPASomewhatActive', N'False' UNION ALL
SELECT 503, 14, 17, N'cbPAActive', N'False' UNION ALL
SELECT 504, 14, 17, N'cbPAHighlyActive', N'False' UNION ALL
SELECT 505, 15, 17, N'rbPregnantYes', N'False' UNION ALL
SELECT 506, 15, 17, N'rbPregnantNo', N'True' UNION ALL
SELECT 507, 15, 17, N'rbPregnantUnknown', N'False' UNION ALL
SELECT 508, 16, 17, N'tbCurrentMedications', N'' UNION ALL
SELECT 509, 17, 17, N'tbCurrentVitamins', N'' UNION ALL
SELECT 510, 18, 17, N'tbCurrentSupplements', N'' UNION ALL
SELECT 511, 19, 17, N'tbPastSurgeries', N'' UNION ALL
SELECT 512, 20, 17, N'cbNotTakingMedsVitsSuppls', N'False' UNION ALL
SELECT 513, 21, 17, N'cbNoSurgeries', N'False' UNION ALL
SELECT 514, 22, 17, N'cbDiagnosedArthritis', N'False' UNION ALL
SELECT 515, 22, 17, N'cbDiagnosedCancer', N'False' UNION ALL
SELECT 516, 22, 17, N'cbDiagnosedDiabetes', N'True' UNION ALL
SELECT 517, 22, 17, N'cbDiagnosedDyslipidemia', N'False' UNION ALL
SELECT 518, 22, 17, N'cbDiagnosedHIV', N'True' UNION ALL
SELECT 519, 22, 17, N'cbDiagnosedHypertension', N'True' UNION ALL
SELECT 520, 22, 17, N'cbDiagnosedMetabolicSyndrome', N'True' UNION ALL
SELECT 521, 22, 17, N'cbDiagnosedObese', N'False' UNION ALL
SELECT 522, 22, 17, N'cbDiagnosedOsteoporosis', N'False' UNION ALL
SELECT 523, 22, 17, N'cbDiagnosedPAD', N'False' UNION ALL
SELECT 524, 22, 17, N'cbDiagnosedRenalDisease', N'True' UNION ALL
SELECT 525, 22, 17, N'cbDiagnosedOther', N'False' UNION ALL
SELECT 526, 23, 17, N'cbAgeMale45Up', N'False' UNION ALL
SELECT 527, 23, 17, N'cbAgeFemale55Up', N'True' UNION ALL
SELECT 528, 23, 17, N'cbAgeFemalePreMenopause', N'False' UNION ALL
SELECT 529, 24, 17, N'cbDiagnosedDiseaseCardio', N'False' UNION ALL
SELECT 530, 24, 17, N'cbDiagnosedDiseasePulmonary', N'False'
COMMIT;
RAISERROR (N'[dbo].[QuestionAnswer]: Insert Batch: 7.....Done!', 10, 1) WITH NOWAIT;
GO

BEGIN TRANSACTION;
INSERT INTO [dbo].[QuestionAnswer]([AnswerID], [QuestionID], [UserID], [FieldName], [FieldValue])
SELECT 531, 24, 17, N'cbDiagnosedDiseaseMetabolic', N'True' UNION ALL
SELECT 532, 24, 17, N'cbDiagnosedDiseaseUnknown', N'True' UNION ALL
SELECT 533, 24, 17, N'cbDiagnosedDiseaseNone', N'False' UNION ALL
SELECT 534, 25, 17, N'cbSuddenDeathMale', N'False' UNION ALL
SELECT 535, 25, 17, N'cbSuddenDeathFemale', N'True' UNION ALL
SELECT 536, 25, 17, N'cbSuddenDeathUnknown', N'True' UNION ALL
SELECT 537, 25, 17, N'cbSuddenDeathNone', N'False' UNION ALL
SELECT 538, 26, 17, N'cbHypertensionSystolic', N'True' UNION ALL
SELECT 539, 26, 17, N'cbHypertensionDiastolic', N'False' UNION ALL
SELECT 540, 26, 17, N'cbHypertensionMedication', N'False' UNION ALL
SELECT 541, 26, 17, N'cbHypertensionUnknown', N'False' UNION ALL
SELECT 542, 26, 17, N'cbHypertensionNormal', N'False' UNION ALL
SELECT 543, 1, 18, N'tbWeight', N'' UNION ALL
SELECT 544, 3, 18, N'tbHeightft', N'' UNION ALL
SELECT 545, 3, 18, N'tbHeightin', N'' UNION ALL
SELECT 546, 4, 18, N'tbBMI', N'' UNION ALL
SELECT 547, 5, 18, N'tbWaistCircIn', N'' UNION ALL
SELECT 548, 5, 18, N'tbWaistCircCm', N'' UNION ALL
SELECT 549, 6, 18, N'tbBPSystolic', N'' UNION ALL
SELECT 550, 6, 18, N'tbBPDiastolic', N'' UNION ALL
SELECT 551, 8, 18, N'tbRestingHeartRate', N'' UNION ALL
SELECT 552, 9, 18, N'tbBloodGlucose', N'' UNION ALL
SELECT 553, 9, 18, N'cbUnknownBloodGlucose', N'False' UNION ALL
SELECT 554, 10, 18, N'tbTotalCholestorol', N'' UNION ALL
SELECT 555, 10, 18, N'cbTotalCholesterol', N'False' UNION ALL
SELECT 556, 11, 18, N'tbLDLCholesterol', N'' UNION ALL
SELECT 557, 11, 18, N'cbUnknownLDLCholesterol', N'False' UNION ALL
SELECT 558, 12, 18, N'tbHDLCholesterol', N'' UNION ALL
SELECT 559, 12, 18, N'cbUnknownHDLCholesterol', N'False' UNION ALL
SELECT 560, 14, 18, N'cbPASedentary', N'False' UNION ALL
SELECT 561, 14, 18, N'cbPAMinimallyActive', N'False' UNION ALL
SELECT 562, 14, 18, N'cbPASomewhatActive', N'False' UNION ALL
SELECT 563, 14, 18, N'cbPAActive', N'False' UNION ALL
SELECT 564, 14, 18, N'cbPAHighlyActive', N'False' UNION ALL
SELECT 565, 15, 18, N'rbPregnantYes', N'False' UNION ALL
SELECT 566, 15, 18, N'rbPregnantNo', N'False' UNION ALL
SELECT 567, 15, 18, N'rbPregnantUnknown', N'False' UNION ALL
SELECT 568, 16, 18, N'tbCurrentMedications', N'' UNION ALL
SELECT 569, 17, 18, N'tbCurrentVitamins', N'' UNION ALL
SELECT 570, 18, 18, N'tbCurrentSupplements', N'' UNION ALL
SELECT 571, 19, 18, N'tbPastSurgeries', N'' UNION ALL
SELECT 572, 20, 18, N'cbNotTakingMedsVitsSuppls', N'False' UNION ALL
SELECT 573, 21, 18, N'cbNoSurgeries', N'False' UNION ALL
SELECT 574, 22, 18, N'cbDiagnosedArthritis', N'False' UNION ALL
SELECT 575, 22, 18, N'cbDiagnosedCancer', N'False' UNION ALL
SELECT 576, 22, 18, N'cbDiagnosedDiabetes', N'False' UNION ALL
SELECT 577, 22, 18, N'cbDiagnosedDyslipidemia', N'False' UNION ALL
SELECT 578, 22, 18, N'cbDiagnosedHIV', N'False' UNION ALL
SELECT 579, 22, 18, N'cbDiagnosedHypertension', N'False' UNION ALL
SELECT 580, 22, 18, N'cbDiagnosedMetabolicSyndrome', N'False'
COMMIT;
RAISERROR (N'[dbo].[QuestionAnswer]: Insert Batch: 8.....Done!', 10, 1) WITH NOWAIT;
GO

BEGIN TRANSACTION;
INSERT INTO [dbo].[QuestionAnswer]([AnswerID], [QuestionID], [UserID], [FieldName], [FieldValue])
SELECT 581, 22, 18, N'cbDiagnosedObese', N'False' UNION ALL
SELECT 582, 22, 18, N'cbDiagnosedOsteoporosis', N'False' UNION ALL
SELECT 583, 22, 18, N'cbDiagnosedPAD', N'False' UNION ALL
SELECT 584, 22, 18, N'cbDiagnosedRenalDisease', N'False' UNION ALL
SELECT 585, 22, 18, N'cbDiagnosedOther', N'False' UNION ALL
SELECT 586, 23, 18, N'cbAgeMale45Up', N'False' UNION ALL
SELECT 587, 23, 18, N'cbAgeFemale55Up', N'False' UNION ALL
SELECT 588, 23, 18, N'cbAgeFemalePreMenopause', N'False' UNION ALL
SELECT 589, 24, 18, N'cbDiagnosedDiseaseCardio', N'False' UNION ALL
SELECT 590, 24, 18, N'cbDiagnosedDiseasePulmonary', N'False' UNION ALL
SELECT 591, 24, 18, N'cbDiagnosedDiseaseMetabolic', N'False' UNION ALL
SELECT 592, 24, 18, N'cbDiagnosedDiseaseUnknown', N'False' UNION ALL
SELECT 593, 24, 18, N'cbDiagnosedDiseaseNone', N'False' UNION ALL
SELECT 594, 25, 18, N'cbSuddenDeathMale', N'False' UNION ALL
SELECT 595, 25, 18, N'cbSuddenDeathFemale', N'False' UNION ALL
SELECT 596, 25, 18, N'cbSuddenDeathUnknown', N'False' UNION ALL
SELECT 597, 25, 18, N'cbSuddenDeathNone', N'False' UNION ALL
SELECT 598, 26, 18, N'cbHypertensionSystolic', N'False' UNION ALL
SELECT 599, 26, 18, N'cbHypertensionDiastolic', N'False' UNION ALL
SELECT 600, 26, 18, N'cbHypertensionMedication', N'False' UNION ALL
SELECT 601, 26, 18, N'cbHypertensionUnknown', N'False' UNION ALL
SELECT 602, 26, 18, N'cbHypertensionNormal', N'False' UNION ALL
SELECT 663, 1, 27, N'tbWeight', N'100' UNION ALL
SELECT 664, 3, 27, N'tbHeightft', N'1' UNION ALL
SELECT 665, 3, 27, N'tbHeightin', N'0' UNION ALL
SELECT 666, 4, 27, N'tbBMI', N'27' UNION ALL
SELECT 667, 5, 27, N'tbWaistCircIn', N'28' UNION ALL
SELECT 668, 5, 27, N'tbWaistCircCm', N'3' UNION ALL
SELECT 669, 6, 27, N'tbBPSystolic', N'129' UNION ALL
SELECT 670, 6, 27, N'tbBPDiastolic', N'67' UNION ALL
SELECT 671, 8, 27, N'tbRestingHeartRate', N'234' UNION ALL
SELECT 672, 9, 27, N'tbBloodGlucose', N'123' UNION ALL
SELECT 673, 9, 27, N'cbUnknownBloodGlucose', N'False' UNION ALL
SELECT 674, 10, 27, N'tbTotalCholestorol', N'234' UNION ALL
SELECT 675, 10, 27, N'cbTotalCholesterol', N'False' UNION ALL
SELECT 676, 11, 27, N'tbLDLCholesterol', N'22' UNION ALL
SELECT 677, 11, 27, N'cbUnknownLDLCholesterol', N'False' UNION ALL
SELECT 678, 12, 27, N'tbHDLCholesterol', N'123' UNION ALL
SELECT 679, 12, 27, N'cbUnknownHDLCholesterol', N'False' UNION ALL
SELECT 680, 14, 27, N'cbPASedentary', N'True' UNION ALL
SELECT 681, 14, 27, N'cbPAMinimallyActive', N'False' UNION ALL
SELECT 682, 14, 27, N'cbPASomewhatActive', N'False' UNION ALL
SELECT 683, 14, 27, N'cbPAActive', N'False' UNION ALL
SELECT 684, 14, 27, N'cbPAHighlyActive', N'False' UNION ALL
SELECT 685, 15, 27, N'rbPregnantYes', N'False' UNION ALL
SELECT 686, 15, 27, N'rbPregnantNo', N'False' UNION ALL
SELECT 687, 15, 27, N'rbPregnantUnknown', N'True' UNION ALL
SELECT 688, 16, 27, N'tbCurrentMedications', N'' UNION ALL
SELECT 689, 17, 27, N'tbCurrentVitamins', N'' UNION ALL
SELECT 690, 18, 27, N'tbCurrentSupplements', N''
COMMIT;
RAISERROR (N'[dbo].[QuestionAnswer]: Insert Batch: 9.....Done!', 10, 1) WITH NOWAIT;
GO

BEGIN TRANSACTION;
INSERT INTO [dbo].[QuestionAnswer]([AnswerID], [QuestionID], [UserID], [FieldName], [FieldValue])
SELECT 691, 19, 27, N'tbPastSurgeries', N'' UNION ALL
SELECT 692, 20, 27, N'cbNotTakingMedsVitsSuppls', N'False' UNION ALL
SELECT 693, 21, 27, N'cbNoSurgeries', N'False' UNION ALL
SELECT 694, 22, 27, N'cbDiagnosedArthritis', N'False' UNION ALL
SELECT 695, 22, 27, N'cbDiagnosedCancer', N'False' UNION ALL
SELECT 696, 22, 27, N'cbDiagnosedDiabetes', N'False' UNION ALL
SELECT 697, 22, 27, N'cbDiagnosedDyslipidemia', N'False' UNION ALL
SELECT 698, 22, 27, N'cbDiagnosedHIV', N'False' UNION ALL
SELECT 699, 22, 27, N'cbDiagnosedHypertension', N'False' UNION ALL
SELECT 700, 22, 27, N'cbDiagnosedMetabolicSyndrome', N'False' UNION ALL
SELECT 701, 22, 27, N'cbDiagnosedObese', N'False' UNION ALL
SELECT 702, 22, 27, N'cbDiagnosedOsteoporosis', N'False' UNION ALL
SELECT 703, 22, 27, N'cbDiagnosedPAD', N'False' UNION ALL
SELECT 704, 22, 27, N'cbDiagnosedRenalDisease', N'False' UNION ALL
SELECT 705, 22, 27, N'cbDiagnosedOther', N'False' UNION ALL
SELECT 706, 23, 27, N'cbAgeMale45Up', N'False' UNION ALL
SELECT 707, 23, 27, N'cbAgeFemale55Up', N'False' UNION ALL
SELECT 708, 23, 27, N'cbAgeFemalePreMenopause', N'True' UNION ALL
SELECT 709, 24, 27, N'cbDiagnosedDiseaseCardio', N'False' UNION ALL
SELECT 710, 24, 27, N'cbDiagnosedDiseasePulmonary', N'False' UNION ALL
SELECT 711, 24, 27, N'cbDiagnosedDiseaseMetabolic', N'False' UNION ALL
SELECT 712, 24, 27, N'cbDiagnosedDiseaseUnknown', N'False' UNION ALL
SELECT 713, 24, 27, N'cbDiagnosedDiseaseNone', N'True' UNION ALL
SELECT 714, 25, 27, N'cbSuddenDeathMale', N'False' UNION ALL
SELECT 715, 25, 27, N'cbSuddenDeathFemale', N'False' UNION ALL
SELECT 716, 25, 27, N'cbSuddenDeathUnknown', N'False' UNION ALL
SELECT 717, 25, 27, N'cbSuddenDeathNone', N'True' UNION ALL
SELECT 718, 26, 27, N'cbHypertensionSystolic', N'False' UNION ALL
SELECT 719, 26, 27, N'cbHypertensionDiastolic', N'False' UNION ALL
SELECT 720, 26, 27, N'cbHypertensionMedication', N'True' UNION ALL
SELECT 721, 26, 27, N'cbHypertensionUnknown', N'False' UNION ALL
SELECT 722, 26, 27, N'cbHypertensionNormal', N'False' UNION ALL
SELECT 723, 1, 29, N'tbWeight', N'160' UNION ALL
SELECT 724, 3, 29, N'tbHeightft', N'6' UNION ALL
SELECT 725, 3, 29, N'tbHeightin', N'0' UNION ALL
SELECT 726, 4, 29, N'tbBMI', N'' UNION ALL
SELECT 727, 5, 29, N'tbWaistCircIn', N'32' UNION ALL
SELECT 728, 5, 29, N'tbWaistCircCm', N'' UNION ALL
SELECT 729, 6, 29, N'tbBPSystolic', N'324' UNION ALL
SELECT 730, 6, 29, N'tbBPDiastolic', N'321' UNION ALL
SELECT 731, 8, 29, N'tbRestingHeartRate', N'60' UNION ALL
SELECT 732, 9, 29, N'tbBloodGlucose', N'1' UNION ALL
SELECT 733, 9, 29, N'cbUnknownBloodGlucose', N'False' UNION ALL
SELECT 734, 10, 29, N'tbTotalCholestorol', N'1' UNION ALL
SELECT 735, 10, 29, N'cbTotalCholesterol', N'False' UNION ALL
SELECT 736, 11, 29, N'tbLDLCholesterol', N'1' UNION ALL
SELECT 737, 11, 29, N'cbUnknownLDLCholesterol', N'False' UNION ALL
SELECT 738, 12, 29, N'tbHDLCholesterol', N'1' UNION ALL
SELECT 739, 12, 29, N'cbUnknownHDLCholesterol', N'False' UNION ALL
SELECT 740, 14, 29, N'cbPASedentary', N'True'
COMMIT;
RAISERROR (N'[dbo].[QuestionAnswer]: Insert Batch: 10.....Done!', 10, 1) WITH NOWAIT;
GO

BEGIN TRANSACTION;
INSERT INTO [dbo].[QuestionAnswer]([AnswerID], [QuestionID], [UserID], [FieldName], [FieldValue])
SELECT 741, 14, 29, N'cbPAMinimallyActive', N'True' UNION ALL
SELECT 742, 14, 29, N'cbPASomewhatActive', N'False' UNION ALL
SELECT 743, 14, 29, N'cbPAActive', N'False' UNION ALL
SELECT 744, 14, 29, N'cbPAHighlyActive', N'False' UNION ALL
SELECT 745, 15, 29, N'rbPregnantYes', N'True' UNION ALL
SELECT 746, 15, 29, N'rbPregnantNo', N'False' UNION ALL
SELECT 747, 15, 29, N'rbPregnantUnknown', N'False' UNION ALL
SELECT 748, 16, 29, N'tbCurrentMedications', N'' UNION ALL
SELECT 749, 17, 29, N'tbCurrentVitamins', N'' UNION ALL
SELECT 750, 18, 29, N'tbCurrentSupplements', N'' UNION ALL
SELECT 751, 19, 29, N'tbPastSurgeries', N'' UNION ALL
SELECT 752, 20, 29, N'cbNotTakingMedsVitsSuppls', N'False' UNION ALL
SELECT 753, 21, 29, N'cbNoSurgeries', N'False' UNION ALL
SELECT 754, 22, 29, N'cbDiagnosedArthritis', N'True' UNION ALL
SELECT 755, 22, 29, N'cbDiagnosedCancer', N'False' UNION ALL
SELECT 756, 22, 29, N'cbDiagnosedDiabetes', N'False' UNION ALL
SELECT 757, 22, 29, N'cbDiagnosedDyslipidemia', N'False' UNION ALL
SELECT 758, 22, 29, N'cbDiagnosedHIV', N'False' UNION ALL
SELECT 759, 22, 29, N'cbDiagnosedHypertension', N'False' UNION ALL
SELECT 760, 22, 29, N'cbDiagnosedMetabolicSyndrome', N'False' UNION ALL
SELECT 761, 22, 29, N'cbDiagnosedObese', N'False' UNION ALL
SELECT 762, 22, 29, N'cbDiagnosedOsteoporosis', N'False' UNION ALL
SELECT 763, 22, 29, N'cbDiagnosedPAD', N'False' UNION ALL
SELECT 764, 22, 29, N'cbDiagnosedRenalDisease', N'False' UNION ALL
SELECT 765, 22, 29, N'cbDiagnosedOther', N'False' UNION ALL
SELECT 766, 23, 29, N'cbAgeMale45Up', N'True' UNION ALL
SELECT 767, 23, 29, N'cbAgeFemale55Up', N'False' UNION ALL
SELECT 768, 23, 29, N'cbAgeFemalePreMenopause', N'False' UNION ALL
SELECT 769, 24, 29, N'cbDiagnosedDiseaseCardio', N'True' UNION ALL
SELECT 770, 24, 29, N'cbDiagnosedDiseasePulmonary', N'False' UNION ALL
SELECT 771, 24, 29, N'cbDiagnosedDiseaseMetabolic', N'False' UNION ALL
SELECT 772, 24, 29, N'cbDiagnosedDiseaseUnknown', N'False' UNION ALL
SELECT 773, 24, 29, N'cbDiagnosedDiseaseNone', N'False' UNION ALL
SELECT 774, 25, 29, N'cbSuddenDeathMale', N'True' UNION ALL
SELECT 775, 25, 29, N'cbSuddenDeathFemale', N'False' UNION ALL
SELECT 776, 25, 29, N'cbSuddenDeathUnknown', N'False' UNION ALL
SELECT 777, 25, 29, N'cbSuddenDeathNone', N'False' UNION ALL
SELECT 778, 26, 29, N'cbHypertensionSystolic', N'True' UNION ALL
SELECT 779, 26, 29, N'cbHypertensionDiastolic', N'False' UNION ALL
SELECT 780, 26, 29, N'cbHypertensionMedication', N'False' UNION ALL
SELECT 781, 26, 29, N'cbHypertensionUnknown', N'False' UNION ALL
SELECT 782, 26, 29, N'cbHypertensionNormal', N'False' UNION ALL
SELECT 783, 1, 30, N'tbWeight', N'200' UNION ALL
SELECT 784, 3, 30, N'tbHeightft', N'5' UNION ALL
SELECT 785, 3, 30, N'tbHeightin', N'8' UNION ALL
SELECT 786, 4, 30, N'tbBMI', N'28' UNION ALL
SELECT 787, 5, 30, N'tbWaistCircIn', N'35' UNION ALL
SELECT 788, 5, 30, N'tbWaistCircCm', N'' UNION ALL
SELECT 789, 6, 30, N'tbBPSystolic', N'115' UNION ALL
SELECT 790, 6, 30, N'tbBPDiastolic', N''
COMMIT;
RAISERROR (N'[dbo].[QuestionAnswer]: Insert Batch: 11.....Done!', 10, 1) WITH NOWAIT;
GO

BEGIN TRANSACTION;
INSERT INTO [dbo].[QuestionAnswer]([AnswerID], [QuestionID], [UserID], [FieldName], [FieldValue])
SELECT 791, 8, 30, N'tbRestingHeartRate', N'75' UNION ALL
SELECT 792, 9, 30, N'tbBloodGlucose', N'' UNION ALL
SELECT 793, 9, 30, N'cbUnknownBloodGlucose', N'True' UNION ALL
SELECT 794, 10, 30, N'tbTotalCholestorol', N'' UNION ALL
SELECT 795, 10, 30, N'cbTotalCholesterol', N'True' UNION ALL
SELECT 796, 11, 30, N'tbLDLCholesterol', N'' UNION ALL
SELECT 797, 11, 30, N'cbUnknownLDLCholesterol', N'True' UNION ALL
SELECT 798, 12, 30, N'tbHDLCholesterol', N'' UNION ALL
SELECT 799, 12, 30, N'cbUnknownHDLCholesterol', N'True' UNION ALL
SELECT 800, 14, 30, N'cbPASedentary', N'False' UNION ALL
SELECT 801, 14, 30, N'cbPAMinimallyActive', N'True' UNION ALL
SELECT 802, 14, 30, N'cbPASomewhatActive', N'False' UNION ALL
SELECT 803, 14, 30, N'cbPAActive', N'False' UNION ALL
SELECT 804, 14, 30, N'cbPAHighlyActive', N'False' UNION ALL
SELECT 805, 15, 30, N'rbPregnantYes', N'False' UNION ALL
SELECT 806, 15, 30, N'rbPregnantNo', N'True' UNION ALL
SELECT 807, 15, 30, N'rbPregnantUnknown', N'False' UNION ALL
SELECT 808, 16, 30, N'tbCurrentMedications', N'None' UNION ALL
SELECT 809, 17, 30, N'tbCurrentVitamins', N'Multi Vitamin' UNION ALL
SELECT 810, 18, 30, N'tbCurrentSupplements', N'None' UNION ALL
SELECT 811, 19, 30, N'tbPastSurgeries', N'None' UNION ALL
SELECT 812, 20, 30, N'cbNotTakingMedsVitsSuppls', N'False' UNION ALL
SELECT 813, 21, 30, N'cbNoSurgeries', N'True' UNION ALL
SELECT 814, 22, 30, N'cbDiagnosedArthritis', N'True' UNION ALL
SELECT 815, 22, 30, N'cbDiagnosedCancer', N'False' UNION ALL
SELECT 816, 22, 30, N'cbDiagnosedDiabetes', N'False' UNION ALL
SELECT 817, 22, 30, N'cbDiagnosedDyslipidemia', N'False' UNION ALL
SELECT 818, 22, 30, N'cbDiagnosedHIV', N'False' UNION ALL
SELECT 819, 22, 30, N'cbDiagnosedHypertension', N'False' UNION ALL
SELECT 820, 22, 30, N'cbDiagnosedMetabolicSyndrome', N'False' UNION ALL
SELECT 821, 22, 30, N'cbDiagnosedObese', N'False' UNION ALL
SELECT 822, 22, 30, N'cbDiagnosedOsteoporosis', N'False' UNION ALL
SELECT 823, 22, 30, N'cbDiagnosedPAD', N'False' UNION ALL
SELECT 824, 22, 30, N'cbDiagnosedRenalDisease', N'False' UNION ALL
SELECT 825, 22, 30, N'cbDiagnosedOther', N'False' UNION ALL
SELECT 826, 23, 30, N'cbAgeMale45Up', N'False' UNION ALL
SELECT 827, 23, 30, N'cbAgeFemale55Up', N'True' UNION ALL
SELECT 828, 23, 30, N'cbAgeFemalePreMenopause', N'False' UNION ALL
SELECT 829, 24, 30, N'cbDiagnosedDiseaseCardio', N'False' UNION ALL
SELECT 830, 24, 30, N'cbDiagnosedDiseasePulmonary', N'False' UNION ALL
SELECT 831, 24, 30, N'cbDiagnosedDiseaseMetabolic', N'False' UNION ALL
SELECT 832, 24, 30, N'cbDiagnosedDiseaseUnknown', N'False' UNION ALL
SELECT 833, 24, 30, N'cbDiagnosedDiseaseNone', N'True' UNION ALL
SELECT 834, 25, 30, N'cbSuddenDeathMale', N'False' UNION ALL
SELECT 835, 25, 30, N'cbSuddenDeathFemale', N'False' UNION ALL
SELECT 836, 25, 30, N'cbSuddenDeathUnknown', N'False' UNION ALL
SELECT 837, 25, 30, N'cbSuddenDeathNone', N'True' UNION ALL
SELECT 838, 26, 30, N'cbHypertensionSystolic', N'True' UNION ALL
SELECT 839, 26, 30, N'cbHypertensionDiastolic', N'False' UNION ALL
SELECT 840, 26, 30, N'cbHypertensionMedication', N'False'
COMMIT;
RAISERROR (N'[dbo].[QuestionAnswer]: Insert Batch: 12.....Done!', 10, 1) WITH NOWAIT;
GO

BEGIN TRANSACTION;
INSERT INTO [dbo].[QuestionAnswer]([AnswerID], [QuestionID], [UserID], [FieldName], [FieldValue])
SELECT 841, 26, 30, N'cbHypertensionUnknown', N'False' UNION ALL
SELECT 842, 26, 30, N'cbHypertensionNormal', N'False' UNION ALL
SELECT 843, 23, 6, N'cbAgeMale45Up', N'False' UNION ALL
SELECT 844, 23, 6, N'cbAgeFemale55Up', N'True' UNION ALL
SELECT 845, 23, 6, N'cbAgeFemalePreMenopause', N'False' UNION ALL
SELECT 846, 24, 6, N'cbDiagnosedDiseaseCardio', N'False' UNION ALL
SELECT 847, 24, 6, N'cbDiagnosedDiseasePulmonary', N'False' UNION ALL
SELECT 848, 24, 6, N'cbDiagnosedDiseaseMetabolic', N'False' UNION ALL
SELECT 849, 24, 6, N'cbDiagnosedDiseaseUnknown', N'True' UNION ALL
SELECT 850, 24, 6, N'cbDiagnosedDiseaseNone', N'False' UNION ALL
SELECT 851, 25, 6, N'cbSuddenDeathMale', N'False' UNION ALL
SELECT 852, 25, 6, N'cbSuddenDeathFemale', N'True' UNION ALL
SELECT 853, 25, 6, N'cbSuddenDeathUnknown', N'False' UNION ALL
SELECT 854, 25, 6, N'cbSuddenDeathNone', N'False' UNION ALL
SELECT 855, 26, 6, N'cbHypertensionSystolic', N'False' UNION ALL
SELECT 856, 26, 6, N'cbHypertensionDiastolic', N'False' UNION ALL
SELECT 857, 26, 6, N'cbHypertensionMedication', N'True' UNION ALL
SELECT 858, 26, 6, N'cbHypertensionUnknown', N'False' UNION ALL
SELECT 859, 26, 6, N'cbHypertensionNormal', N'False' UNION ALL
SELECT 917, 23, 1, N'cbAgeNoneAbove', N'True'
COMMIT;
RAISERROR (N'[dbo].[QuestionAnswer]: Insert Batch: 13.....Done!', 10, 1) WITH NOWAIT;
GO

SET IDENTITY_INSERT [dbo].[QuestionAnswer] OFF;

